Overview
What is PostgreSQL?
PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
Best Relational and Open Source Database
postgreSQL, a great choice from startup to enterprise
"PostgreSQL is the most sophisticated and adaptable database software available."
PostgreSQL Review
PostgreSQL has rich feature sets and it's completely free!
Cost Effective but Super Performing PostgreSQL Database!
Don't be afraid on adopting it. PostgreSQL delivers more features than most of the paid databases from big brands.
PostgreSQL you don't want to stop using it
Best open source relational database you can have
Postgres - tons of people use it for a reason!!
PostgreSQL is awesome opensource database with NoSQL support
Professional and Free
PostgreSQL, the best data retrieval
This is used by the IT department only, …
PostgreSQL for yesterday AND today's data requirements
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Product Demos
PostgreSQL for Beginners - Demos on pgbouncer
PostgreSQL demo with CPP on Ubuntu Linux
Spring Boot + Vue.js example | Spring Data JPA + REST + PostgreSQL CRUD Demo
ASP.Net Core Web API con Docker Compose, PostgreSQL y EF Core
Demo: Replicating Oracle Database to PostgreSQL - TechXperts
postgresql conf demo
Product Details
- About
- Integrations
- Tech Details
- FAQs
What is PostgreSQL?
PostgreSQL Video
PostgreSQL Integrations
PostgreSQL Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(322)Community Insights
- Business Problems Solved
- Pros
- Cons
- Recommendations
PostgreSQL has a wide range of use cases across various industries and organizations. It is commonly used as a primary data storage solution for traditional relational data in customer-facing systems, serving as a reliable and scalable option. Additionally, PostgreSQL is utilized as a NoSQL data store with JSON and JSONB data types, offering flexibility and versatility for developers. Users appreciate its near-complete ANSI SQL language implementation, making it handy for data extraction and analytics. PostgreSQL is also valued for its ease of integration or migration with AWS Redshift, enabling seamless data transfer between platforms. Moreover, it serves as a dedicated and per-application data storage engine, catering to the diverse needs of different business units. Whether it's for data analytics, reporting, ad-hoc data storage and retrieval, or building high-traffic API services, PostgreSQL proves to be a stable and cost-effective solution for various use cases.
Reliability and Performance: Users have consistently praised PostgreSQL for its reliability and performance, with many reviewers stating that they have experienced no downtime or issues related to the database. Some users also mentioned that PostgreSQL's performance is exceptionally fast, providing them with great speed in their operations.
Ease of Use and Flexibility: Many users find PostgreSQL easy to use and appreciate the availability of good open-source tools to work with it. Reviewers have highlighted that constructing queries in PostgreSQL is straightforward and that it integrates well with all development languages, making migration easy. The flexibility of PostgreSQL's user/role management system has also been praised by users, as it allows for easy control over access to tables.
Wide Industry Adoption and Community Support: Several reviewers acknowledge that PostgreSQL has achieved wide industry adoption, making it easier to integrate into a stack and hire knowledgeable developers. The availability of a huge online community for support was highly appreciated by users. Additionally, many users mentioned the extensive documentation available for PostgreSQL, along with the ease of finding examples, which further contributes to community support.
Complicated Installation and Setup: Many users have found the installation and setup process of PostgreSQL to be complicated, especially for Mac users. They have mentioned the need to learn new commands and have recommended blog posts for guidance.
Difficult Syntax of SQL: Users have expressed difficulty in understanding the syntax of SQL in PostgreSQL, which they find different and hard to grasp. This may be a reason why the software is not widely adopted.
Lack of Clear Benefits: Users have mentioned the lack of clear benefits for choosing PostgreSQL over other products. They feel that there are better alternatives available with more extensive features, documentation, and community support.
Based on user reviews, PostgreSQL is recommended for its ease of use, fast execution, and compatibility with other PostgreSQL users. Users also find its functionality, friendly SQL operations, and good GUI feature beneficial. It is suggested as an alternative to other complex query language platforms.
Reviewers highly recommend PostgreSQL for its scalability, robustness, and reliability. They believe it is the best relational database with great popularity among developers. It is suggested for work, learning, career purposes, as well as small and medium development projects. Users also mention its suitability for incremental development and cost reduction.
PostgreSQL is praised as a world-class and free database with a vibrant community that provides great support. Reviewers recommend it for its cost-effectiveness and suitability as a free relational database. It is suggested as the default database choice for developers, including testing and staging environments. The growing community around PostgreSQL is seen as an advantage.
Other notable recommendations include the speed, security, and reliability of PostgreSQL. It is considered suitable for querying large amounts of data and prioritizing security. Users emphasize the importance of familiarizing oneself with SQL, utilizing the documentation, and keeping up with the latest versions of PostgreSQL. They suggest having database experts on the team for production use.
Additionally, users suggest using PostgreSQL for lightweight installations, optimal database management, building reporting engines, data analysis with good security features at an affordable price, and implementation in systems with array support.
Some users request improvements such as easier configuration processes for Windows users or adding real-time database support or developing another database app. Online resources are recommended for training and support when learning PostgreSQL.
Overall, users find PostgreSQL to be a complete and easily accessible database system with multi-version concurrency support that offers a reliable solution for various needs.
Attribute Ratings
Reviews
(1-7 of 7)- It works well with external data sources and runs on platforms with stable performance.
- Clients can rest assured that their personal information will be safe and secure.
- Many forums discuss setup and usage, and most are free.
- Adding tooling applications to a computer is unlimited.
- PostgreSQL runs on many OS platforms and supports ANSI SQL, stored procedures, and triggers.
- Increasing horizontal scaling is complex, but PostgreSQL may have a solution for all replicas to accept operations.
- No column re-ordering and better data compression are required.
- PostgreSQL is often criticized for being slow and unsuitable for large-scale enterprise applications.
We have a lot of microservices applications since PostgreSQL is free, we could use as many database instances as we need without massive cost increase.
The main thing that we like is PostgreSQL supports the JSON column and query which is really useful in our use case.
- Support the JSON column and able to query by the JSON value.
- Free to use.
- Has fairly high performance.
- Installation and configuration can be difficult for first time users.
- Somewhat hard to upgrade/update, especially for major releases.
- Less online documentation and resources available compared to MySQL or SQL Server.
The learning curve is a bit steep compared to MySQL and SQL Server, so might not be suited for a beginner.
PostgreSQL you don't want to stop using it
- The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
- The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
- The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
- The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.
- PostgreSQL installation must be homogeneous across all supported operating systems
- It would be helpful to have an index of compatible tools, plugins or complementary applications within itself to increase productivity.
- Regarding the administration of PostgreSQL itself, it would be very helpful to have a dashboard that will show us the insecurities of security, stability and operability in order to have an overview of PostgreSQL behavior.
PostgreSQL is making a comeback!
- Redundancy and clustering can be handled in multiple different ways, offering complete control over specific use cases.
- GIS extension for spatial data.
- Full SQL compliance.
- A little lighter on resources than SQL Server.
- The documentation can be sometimes lacking, however, there are lots of online resources for troubleshooting.
- The tooling could be better. If you're used to SQL Server Management Studio and all the 3rd party add-ons, moving to PostgreSQL can be hard to get used to at first.
- If you are on a version older than 11, you cannot use Transactions in Stored Procedures. While this isn't an issue moving forward, not all cloud providers support version 11 yet.
PostgreSQL - A great database at a great price.
- The biggest reason I have used postgreSQL and continue to use it in places where I work - is the cost. There is none. It is a great feature rich database which doesn't cost you anything.
- When using properly design database, tables, and relationships - we have not ran into any particular database limit
- For my uses I have none. Currently we are developing a new application using the lastest version of PostgreSQL and are exploring any limitations.
- Spatial Analytics and other GIS use cases - PostGIS is an excellent way to get into spatial analytics, loading it up with data is trivial, power is on par with commercial solutions.
- Interactive queries over large (but not huge datasets) - easy to load data, query it with standard SQL, easy to set up and maintain.
- Support for a variety of data types - storing data in the database using semantic types is helpful for deeper analysis.
- Clustering -- we'd love to see clustering built into the product itself instead of third-party
- Parallelization -- PG is already going in this direction, but it will take a few more releases to be there
- Tooling -- we use a third-party tool right now to query PG, would love to see a first-party quality query tool
Ojoswi's review of PostgrSQL Suite
- Edit data after View
- Instantaneous access and update for Tableau extracts hooked to this data source
- Simple syntax for DDL